﻿CREATE TABLE [flcr].[DEVICE_CATEGORY] (
    [DEVICE_CATEGORY_ID] INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]         VARCHAR (50)  NOT NULL,
    [AUDIT_DTTM]         DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]      INT           NOT NULL,
    [AUDIT_MOD_USER]     VARCHAR (50)  NOT NULL,
    [AUDIT_MOD_DTTM]     DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]  INT           NOT NULL,
    [BUILTIN]            BIT           NOT NULL,
    [ACTIVE_FLG]         BIT           NOT NULL,
    [SORT_ORDER]         INT           NOT NULL,
    [DEVICE_CATEGORY_NAME]    VARCHAR (100) NOT NULL,
    [DEVICE_CATEGORY_DESC]    VARCHAR (250) NOT NULL
);

